package com.softtek.base.sugar.web.excel;


import java.util.LinkedHashMap;
import java.util.Map;

/**
 * Author: 居泽平  Date: 13-11-24, 下午11:20
 */
public class ExcelMapExport {


    public static Map<String, String> DEPARTMENT_EXPORT_MAP() {

        Map<String, String> columnPropertyMap = new LinkedHashMap<String, String>();
        //门店信息
        columnPropertyMap.put("interviewUserName", "访问员姓名");
        columnPropertyMap.put("interviewDate", "访问日期");
        columnPropertyMap.put("enterDepartmentDate", "进店时间");
        columnPropertyMap.put("leaveDepartmentDate", "离店时间");
        columnPropertyMap.put("departmentNum", "门店编号");
        columnPropertyMap.put("departmentChannel", "门店渠道");
        columnPropertyMap.put("departmentName", "门店名称");
        columnPropertyMap.put("departmentAddress", "门店地址");
        //问题Q1A
        columnPropertyMap.put("questionOneAAnswer", "a、轩尼诗VSOP 700ml");
        columnPropertyMap.put("questionOneAPrice", "问题Q1A的价格");
        //问题Q1B
        columnPropertyMap.put("questionOneBAnswer", "b、轩尼诗XO 700ml");
        columnPropertyMap.put("questionOneBPrice", "问题Q1B的价格");
        //问题Q1C
        columnPropertyMap.put("questionOneCAnswer", "c、轩尼诗VSOP第五代特别珍藏版 700ml");
        columnPropertyMap.put("questionOneCPrice", "问题Q1C的价格");
        //问题Q1D
        columnPropertyMap.put("questionOneDAnswer", "d、轩尼诗XO第八代珍藏版 700ml");
        columnPropertyMap.put("questionOneDPrice", "问题Q1D的价格");
        //问题Q1E
        columnPropertyMap.put("questionOneEAnswer", "e、马爹利名仕 700ml非礼盒装(Martell NOBLIGE COGNAC)");
        columnPropertyMap.put("questionOneEPrice", "问题Q1E的价格");
        //问题Q1F
        columnPropertyMap.put("questionOneFAnswer", "f、马爹利蓝带 700ml非礼盒装( Martell Cordon Bleu)");
        columnPropertyMap.put("questionOneFPrice", "问题Q1F的价格");
        //问题Q1G
        columnPropertyMap.put("questionOneGAnswer", "g、马爹利鼎盛700ml非礼盒装");
        columnPropertyMap.put("questionOneGPrice", "问题Q1G的价格");
        //问题Q1H
        columnPropertyMap.put("questionOneHAnswer", "h、马爹利XO700ml非礼盒装");
        columnPropertyMap.put("questionOneHPrice", "问题Q1H的价格");
        //问题Q2
        columnPropertyMap.put("questionTwoAnswer", "店内是否有轩尼诗产品地堆/陈列？");
        columnPropertyMap.put("questionTwoTypeA", "a、陈列1类型");
        columnPropertyMap.put("questionTwoNumA", "数量");
        columnPropertyMap.put("questionTwoTypeB", "b、陈列2类型");
        columnPropertyMap.put("questionTwoNumB", "数量");
        columnPropertyMap.put("questionTwoTypeC", "c、陈列3类型");
        columnPropertyMap.put("questionTwoNumC", "数量");
        columnPropertyMap.put("questionTwoTypeD", "d、陈列4类型");
        columnPropertyMap.put("questionTwoNumD", "数量");
        columnPropertyMap.put("questionTwoTypeE", "e、陈列5");
        columnPropertyMap.put("questionTwoNumE", "数量");
        columnPropertyMap.put("questionTwoTypeG", "g、其他地堆/陈列");
        columnPropertyMap.put("questionTwoNumG", "数量");


        //问题Q3
        columnPropertyMap.put("questionThreeAnswer", "门店内是否有轩尼诗柜台卡？");


        //问题Q4
        columnPropertyMap.put("questionFourAnswer", "门店内是否有轩尼诗VSOP试饮活动？");

        //问题Q4.1
        columnPropertyMap.put("questionFourOneAnswerA", "a. 70cl真酒");
        columnPropertyMap.put("questionFourOneAnswerANum", "数量");
        columnPropertyMap.put("questionFourOneAnswerB", "b. 5cl真酒");
        columnPropertyMap.put("questionFourOneAnswerBNum", "数量");
        columnPropertyMap.put("questionFourOneAnswerC", "c. 闻香试纸");
        columnPropertyMap.put("questionFourOneAnswerD", "d. 闻香喷嘴");

        //问题Q5
        columnPropertyMap.put("questionFiveAnswer", "店内是否有以下宣传资料？(需要主动询问)");

        columnPropertyMap.put("questionFiveAnswerA", "a. 门店内是否有轩尼诗产品礼盒介绍单页？");

        columnPropertyMap.put("questionFiveAnswerB", "b. 是否有用平板电脑介绍轩尼诗产品信息？");

        columnPropertyMap.put("questionFiveAnswerC", "c. 门店点是否有轩尼诗促销活动信息？");

        //问题Q6
        columnPropertyMap.put("questionSixAnswer", "针对麦德龙和山姆会员店是否有相关促销活动物料？");

        //问题Q7
        columnPropertyMap.put("questionSevenAnswerOne", "店内是否有轩尼诗促销员？");
        columnPropertyMap.put("questionSevenAnswerTwo", "无促销员原因");

        //问题Q8
        columnPropertyMap.put("questionEightAnswer", "如果店内有轩尼诗促销员，请判断促销员服装类型？");

        //问题Q9
        columnPropertyMap.put("questionNineAnswer", "轩尼诗促销员是否提到轩尼诗活动？");

        //问题Q10
        columnPropertyMap.put("questionTenAnswer", "店内马爹利是否有促销活动？");

        //问题Q11
        columnPropertyMap.put("questionElevenAnswer", "店内人头马是否有促销活动？");


        return columnPropertyMap;
    }


    public static Map<String, String> REPORT_FORM_EXPORT_MAP() {

        Map<String, String> columnPropertyMap = new LinkedHashMap<String, String>();
        //区域
        columnPropertyMap.put("kaSr", "By Region");
        //问题Q1
        columnPropertyMap.put("questionOneAAnswer", "轩尼诗VSOP 700ml");
        columnPropertyMap.put("questionOneBAnswer", "轩尼诗XO 700ml");
        columnPropertyMap.put("questionOneCAnswer", "轩尼诗VSOP第五代特别珍藏版 700ml");
        columnPropertyMap.put("questionOneDAnswer", "轩尼诗XO第八代珍藏版 700ml");
        columnPropertyMap.put("questionOneEAnswer", "马爹利名仕 700ml非礼盒装(Martell NOBLIGE COGNAC)");
        columnPropertyMap.put("questionOneFAnswer", "马爹利蓝带 700ml非礼盒装( Martell Cordon Bleu)");
        columnPropertyMap.put("questionOneGAnswer", "马爹利鼎盛700ml非礼盒装");
        columnPropertyMap.put("questionOneHAnswer", "马爹利XO700ml非礼盒装");


        columnPropertyMap.put("questionOneAPrice", "轩尼诗VSOP 700ml-价格");
        columnPropertyMap.put("questionOneBPrice", "轩尼诗XO 700ml-价格");
        columnPropertyMap.put("questionOneCPrice", "轩尼诗VSOP第五代特别珍藏版 700ml-价格");
        columnPropertyMap.put("questionOneDPrice", "轩尼诗XO第八代珍藏版 700ml-价格");
        columnPropertyMap.put("questionOneEPrice", "马爹利名仕 700ml非礼盒装(Martell NOBLIGE COGNAC)-价格");
        columnPropertyMap.put("questionOneFPrice", "马爹利蓝带 700ml非礼盒装( Martell Cordon Bleu)-价格");
        columnPropertyMap.put("questionOneGPrice", "马爹利鼎盛700ml非礼盒装-价格");
        columnPropertyMap.put("questionOneHPrice", "马爹利XO700ml非礼盒装-价格");

        //问题Q2
        columnPropertyMap.put("questionTwoAnswer", "Q2地堆");

        //问题3
        columnPropertyMap.put("questionThreeAnswer", "Q3台卡");

        //问题4
        columnPropertyMap.put("questionFourAnswer", "Q4试饮活动");

        //问题5
        columnPropertyMap.put("questionFiveAAnswer", "礼盒介绍单页");
        columnPropertyMap.put("questionFiveBAnswer", "平板电脑介绍");

        //问题7
        columnPropertyMap.put("questionSevenAnswer", "Q7促销员");

        //问题8
        columnPropertyMap.put("questionEightAnswerA", "轩尼诗制服");
        columnPropertyMap.put("questionEightAnswerB", "尊尼获加蓝牌制服");
        columnPropertyMap.put("questionEightAnswerC", "其他制服");
        columnPropertyMap.put("questionEightAnswerD", "未着制服");

        // 问题9
        columnPropertyMap.put("questionNineAnswer", "Q9提到轩尼诗活动");
        columnPropertyMap.put("questionTenAnswer", "Q10马爹利促销活动");
        columnPropertyMap.put("questionElevenAnswer", "Q11人头马促销活动");


        return columnPropertyMap;
    }
}
